package com.trkj.dao.jpa;

import java.util.List;

import org.springframework.data.domain.Pageable;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojos.LmbConsumableInvent;

public interface LmbConsumableInventDAO extends CrudRepository<LmbConsumableInvent, String> {
	@Query("select max(c.ciId) from LmbConsumableInvent c where c.ciId like ?1%")
    public String findMaxID(String a);
	
	@Query("select s from LmbConsumableInvent s order by s.ciId desc")
	public List<LmbConsumableInvent> findinventByPage(Pageable pageable);
	
	@Query("select count(*) from LmbConsumableInvent s")
	public long countfindinventByPage();
}
